Have you ever wanted to fill an entire row or column with a series of values? If you’re an Excel user, you can do the same thing in Google Docs. If you haven’t used either, here’s the quick way to do it.
Just type in a couple of numbers in sequence… 1 2 3 works pretty well. You could also put them across a row instead of down a column.
![how-to-use-autofill-on-a-google-docs-spreadsheet-[quick-tips] photo 1](http://tipsgeneral.com/images/no-images.jpg "How To Use AutoFill on a Google Docs Spreadsheet [Quick Tips] photo 1")
Then move your mouse over the dot in the corner until the pointer changes, then just drag it downward (or if you are filling a row instead, you can drag it to the right).
Let go of the mouse, and your data will be automatically filled in.
You could also make it skip by 1 instead, like 2 4 6 8, etc…
If you want to get really fancy, you can use the tip from reader Andy in the comments below… fill in the cells with something else that would normally be in a set, like the days of the week, then drag the blue dot downward…
And you’ll get a full list of days.
The same thing works for other information, basically anything that can be powered with Google Sets, and you can force Google Spreadsheets to always use Google Sets for the information by holding down the Ctrl key.
For example, if you type in Ford, Honda, Toyota, and hold down the Ctrl key while dragging the dot down…
It all works the same way. Sadly there’s no really advanced options like Excel has, but for most uses, this is good enough. Also, we’re aware this is a very simple tip for most of you, but we’re trying to help the beginners out as well!
Do you like to monitor your system but do not want a complicated app to do it with? If you love simplicity and easy configuration then join us as we look at Desktop Info.
While Google dominates the search engine market, there are certainly other alternatives out there such as Bing and Yahoo. Today we’re curious about which one you use, and would you ever consider another one?
If you have a dual monitor setup and each monitor is a different size or height, it can be annoying trying to move the mouse pointer between them. Here is a quick tip that will help make the process easier.
Are you frustrated by always having to change the font size before you create a document it Word? Here’s how you can end that frustration and set your favorite default font size for once and for all!
Are you wanting to improve the search results view at Google and make better use of the webpage space? With a little user script magic you can make those search results look and fit better in your favorite browser.
Download the Pazera Free 3GP to AVI Converter. You’ll have to unzip the download folder, but there is no need to install the application. Just double-click the 3gptoavi.exe file to run the application.
Want to easily convert area, volume, temperature, and many other units? With the Calculator in Windows 7, it’s easy to convert most any unit into another.
Back in Windows XP there was an important Power toy created to enable ClearType for users of LCD screens. Now it’s standard in Windows 7, but you may not know about it. So let’s take a look.
So you’ve got yourself a new computer with Windows 7 and you’re itching to take advantage of it’s ability to stream media across your home network. But, the rest of the family is still on Windows XP and you’re not quite ready to shell out the cash for the upgrades. Well, today we’ll show you how to
If you have other browsers that you use set to “about:blank” for new tabs then you probably feel rather frustrated with Google Chrome’s default New Tab Page. The Blank New Tab extension is the perfect solution to that problem.
![how-to-use-autofill-on-a-google-docs-spreadsheet-[quick-tips] photo 1](http://www.howtogeek.com/wp-content/uploads/2010/04/image231.png "How To Use AutoFill on a Google Docs Spreadsheet [Quick Tips] photo 1")
![how-to-use-autofill-on-a-google-docs-spreadsheet-[quick-tips] photo 2](http://www.howtogeek.com/wp-content/uploads/2010/04/image232.png "How To Use AutoFill on a Google Docs Spreadsheet [Quick Tips] photo 2")
![how-to-use-autofill-on-a-google-docs-spreadsheet-[quick-tips] photo 3](http://www.howtogeek.com/wp-content/uploads/2010/04/image233.png "How To Use AutoFill on a Google Docs Spreadsheet [Quick Tips] photo 3")
![how-to-use-autofill-on-a-google-docs-spreadsheet-[quick-tips] photo 4](http://www.howtogeek.com/wp-content/uploads/2010/04/image234.png "How To Use AutoFill on a Google Docs Spreadsheet [Quick Tips] photo 4")
![how-to-use-autofill-on-a-google-docs-spreadsheet-[quick-tips] photo 5](http://www.howtogeek.com/wp-content/uploads/2010/04/image284.png "How To Use AutoFill on a Google Docs Spreadsheet [Quick Tips] photo 5")
![how-to-use-autofill-on-a-google-docs-spreadsheet-[quick-tips] photo 6](http://www.howtogeek.com/wp-content/uploads/2010/04/image285.png "How To Use AutoFill on a Google Docs Spreadsheet [Quick Tips] photo 6")
![how-to-use-autofill-on-a-google-docs-spreadsheet-[quick-tips] photo 7](http://www.howtogeek.com/wp-content/uploads/2010/04/image286.png "How To Use AutoFill on a Google Docs Spreadsheet [Quick Tips] photo 7")